To search the entire spreadsheet, click a single cell, or,
to search within a specific range of cells, select the range.
On
the toolbar, click Commands and Options , and then click the Sheet
tab.
In the Find what box, type the text or value you want to find.
Notes
By default, Find what searches for cells that include the value you enter in the Find what box. For example, an entry of
"John" finds cells with strings such as "Johnson"
or "Little John." If you want to find cells that contain only the value
you entered and nothing else, select the Entire cell only check
box.
By default, Find what is not case sensitive. If you want to find only those
cells with values that match the case of your entry, select the Match
case check box.